USE [aspnetdb]
GO

-- =============================================
-- Author     :		Anamika Mukherji
-- Create date:       
-- =============================================

create PROCEDURE sp_UserLogout (
	-- Add the parameters for the stored procedure here
	@par_userid int
	)
AS

BEGIN
	UPDATE [User1] 
		SET logged_in=0
		Where [user1].user1_id = @par_userid
END